TimescaleDB Course – PostgreSQL for Time-Series Data | Learn programming by watching videos

youtube

Learn how to supercharge PostgreSQL for time-series data and heavy analytics workloads using the TimescaleDB extension. In this comprehensive course, you will master hypertables, continuous aggregates, and columnar storage by building real-world projects like an AI agent flight recorder and an EV fleet telemetry dashboard. Created by @beau 🏗️ Tiger Data provided a grant to make this course possible. Get $1,000 credit on Tiger Cloud to follow along: Chapters - 0:00:00 Introduction & Database Comparison - 0:01:06 Course Overview - 0:01:28 Sponsor (Tiger Data & Tigercloud) - 0:02:27 What is Time Series Data? - 0:04:19 Projects Overview - 0:05:24 It's Just PostgreSQL - 0:06:54 Example Data Setup - 0:10:20 The 20% of SQL You Need - 0:19:34 Understanding EXPLAIN & ANALYZE - 0:24:59 Pages & Row Storage - 0:26:09 MVCC, Dead Rows & Vacuuming - 0:29:27 Native Postgres Partitioning vs. TimescaleDB - 0:32:42 What is a Hypertable? - 0:33:14 Materialized Views & Summary Tables - 0:37:05 The Dashboard Problem (Web Analytics Scenario) - 0:44:14 Creating a Hypertable - 0:48:43 The Golden Rule: Always Filter by Time - 0:49:31 How Big Should a Chunk Be? - 0:54:21 Testing Hypertable Performance - 0:59:14 Indexing & Chunk Skipping - 1:03:50 Global Unique Indexes & UUID v7 - 1:13:45 Data Locality & Reordering - 1:15:42 The Column Store - 1:18:36 Columnar Compression Techniques - 1:22:58 Segment By & Order By - 1:26:15 Converting Chunks to Column Store - 1:29:03 Compressed Indexes & Bloom Fil